-- 临时表（适合复杂查询）
CREATE TABLE #TempOrders (OrderID INT PRIMARY KEY, TotalAmount DECIMAL(18,2));
INSERT INTO #TempOrders 
SELECT OrderID, TotalAmount FROM Orders WHERE OrderDate > '2023-01-01';

-- 表变量（适合轻量数据）
DECLARE @Products TABLE (ProductID INT, ProductName NVARCHAR(50));
